import quandl
quandl.ApiConfig.api_key = 'xyZvN7wUdZXqUEvLy2uA'
from pandas import DataFrame,Series

class FianceInfo:
    def get_quote_sample(fromDtStr,toDtStr):

        symbols = ['AAPL','MSFT','YHOO']
        data = DataFrame()
        for sym in symbols:
            mydata1 = quandl.get("WIKI/"+sym, start_date=fromDtStr, end_date=toDtStr)
            data[sym]=mydata1['Adj. Close']
        data.columns = symbols

        db = quandl.get("FSE/DBK_X", start_date=fromDtStr, end_date=toDtStr)
        # print(db)
        data['DB'] = db['Close']

        db = quandl.get("WGC/GOLD_DAILY_USD", start_date=fromDtStr, end_date=toDtStr)
        data['GLD'] = db['Value']
        return data